#!/usr/bin/env python
# encoding:utf-8
'''
@author: yangyongjie
@license: (C) Copyright 2013-2017, Node Supply Chain Manager Corporation Limited. 
@contact: deamoncao100@gmail.com
software: garner
@file: category.py
@time: 2022/8/27 21:58
@desc:
'''
from model import db
import datetime
class Categories(db.Model):
    __tablename__ = "category"
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    commodity_id = db.Column(db.ForeignKey("commodity.id"))
    category_name = db.Column(db.String(128), nullable=False)
    status = db.Column(db.Enum("0","1"), nullable=False)
    create_time = db.Column(db.DateTime, default=datetime.datetime.now())